Release 10.1A: OpenEdge Data Management:
SQL Reference

DELETE

Deletes zero, one, or more rows from the specified table that satisfy the search condition specified in the WHERE clause. If the optional WHERE clause is not specified, then the DELETE statement deletes all rows of the specified table.

Syntax

DELETE FROM [ owner_name.] { table_name | view_name } [ WHERE search_condition ] ;

Example

DELETE FROM Customer WHERE Name = 'Surf and Sport';

Note

If the table has primary or candidate keys and there are references from other tables to the rows to be deleted, the statement is rejected.

Authorization

Must have DBA privilege, ownership of the table, or DELETE permission of the table.

Related statements

WHERE clause